【转载】Oracle11g（RAC）补丁安装（31718723，31668908） |
您所在的位置：网站首页 › oracle 11g 补丁 › 【转载】Oracle11g（RAC）补丁安装（31718723，31668908） |
【转载】Oracle11g（RAC）补丁安装（31718723，31668908）
|
Oracle11g(RAC)补丁安装
注：本篇文章也适用于21年第一季度补丁与21年第二季度补丁 安装环境及补丁版本：Oracle版本：11.2.0.4 Linux版本：Red Hat Enterprise Linux Server release 7.6 (Maipo) PSU版本号：p31718723_112040_Linux-x86-64.zip OJVM版本号：p31668908_112040_Linux-x86-64.zip OPatch版本：p6880880_112000_Linux-x86-64_11.2.0.3.27.zip 打补丁前注意事项及要点（划重点！）： 1、备份 (可以救命)！！！ 2、关闭数据库 3、先打GI psu 4、再打DB psu 5、grid用户打 ACFS（在GI psu打完之后才能打） 6、打补丁要指定补丁安装目录：（opatch auto -oh $ORACLE_HOME） 7、打OJVM之前停crs，打那个节点停那个节点，出问题至少还有一个节点正常 8、先把一个节点补丁彻底打完后在打第二个节点 一定要仔细阅读readme！！！！！！！！！！！！！！！！！！！！！！！！！！！！ 一、备份！！！1、将Oracle软件打包备份 $ cd $ORACLE_HOME $ tar -pzcvf oraclehome1.tar *2、将Grid软件打包备份 $ cd $GRID_HOME $ tar -cvf gihome.tar *希望你用不到，但是有备无患，生产环境，补丁打废了，数据库就废了，这也是非常危险的操作。 二、关闭数据库 # su - oracle $ sqlplus / as sysdba SQL> shutdown immediate 三、将Oracle与Grid自带OPatch备份其实改个名字即可 备份ORACLE_HOME下OPatch： # su - oracle $ cd $ORACLE_HOME/OPatch/ $ mv OPatch OPatch20201214 $ exit 备份GRID_HOME下OPatch (环境变量设置的也是ORACLE_HOME)： # su - grid $ cd $ORACLE_HOME/OPatch/ $ mv OPatch OPatch20201214 $ exit 四、root用户上传补丁授权并解压1、更改补丁介质权限 因为刚刚上传的补丁介质属主都为root，为了使oracle用户和grid用户都可以解压安装补丁，所以更改补丁介质权限： # chmod 755 /u01/software/p31668908_112040_Linux-x86-64.zip # chmod 755 /u01/software/p31718723_112040_Linux-x86-64.zip # chmod 755 /u01/software/p6880880_112000_Linux-x86-64_11.2.0.3.27.zip # chown grid:oinstall /u01/software/p31718723_112040_Linux-x86-64.zip # chown oracle:oinstall /u01/software/p31668908_112040_Linux-x86-64.zip # chown grid:oinstall /u01/software/p6880880_112000_Linux-x86-64_11.2.0.3.27.zip2、解压补丁与OPatch（升级OPatch） 1、使用grid用户解压p31718723_112040_Linux-x86-64.zip（PSU）： # su - grid $ unzip /u01/software/p31718723_112040_Linux-x86-64.zip -d /u01/software 2、解压OPatch到GRID_HOME（升级OPatch）： $ unzip /u01/software/p6880880* -d $ORACLE_HOME/ 3、查看opatch版本： $ opatch version OPatch Version: 11.2.0.3.27 OPatch succeeded. $ exit 1、使用oracle用户解压p31668908_112040_Linux-x86-64.zip（OJVM）： # su - oracle $ unzip /u01/software/p31668908_112040_Linux-x86-64.zip -d /u01/software 2、解压OPatch到ORACLE_HOME（升级OPatch）： $ unzip /u01/software/p6880880* -d $ORACLE_HOME/ 3、查看opatch版本： $ opatch version OPatch Version: 11.2.0.3.27 OPatch succeeded. $ exit 五、开始安装补丁解压p31718723_112040_Linux-x86-64.zip的目录中，readme对于补丁使用对象的说明：
1、打31718723（PSU）补丁 （1）打gi psu ----gi psu---- root用户执行以下命令可将GI的 29938455（ocw）、29509309（acfs）、31537677（db psu）三个补丁打上 # OPatch/opatch auto /31718723 -oh 输出如下： # /u01/app/11.2.0.4/grid/OPatch/opatch auto /u01/software/31718723 -oh /u01/app/11.2.0.4/grid Executing /u01/app/11.2.0.4/grid/perl/bin/perl /u01/app/11.2.0.4/grid/OPatch/crs/patch11203.pl -patchdir /u01/software -patchn 3171 8723 -oh /u01/app/11.2.0.4/grid -paramfile /u01/app/11.2.0.4/grid/crs/install/crsconfig_params This is the main log file: /u01/app/11.2.0.4/grid/cfgtoollogs/opatchauto2020-12-14_11-22-22.log This file will show your detected configuration and all the steps that opatchauto attempted to do on your system: /u01/app/11.2.0.4/grid/cfgtoollogs/opatchauto2020-12-14_11-22-22.report.log 2020-12-14 11:22:22: Starting Clusterware Patch Setup Using configuration parameter file: /u01/app/11.2.0.4/grid/crs/install/crsconfig_params Stopping CRS... Stopped CRS successfully patch /u01/software/31718723/29938455 apply successful for home /u01/app/11.2.0.4/grid patch /u01/software/31718723/31537677 apply successful for home /u01/app/11.2.0.4/grid patch /u01/software/31718723/29509309 apply successful for home /u01/app/11.2.0.4/grid Starting CRS... Installing Trace File Analyzer CRS-4123: Oracle High Availability Services has been started. opatch auto succeeded. #查看已经安装的Grid补丁： # su - grid $ opatch lspatches 29509309;ACFS Patch Set Update : 11.2.0.4.190716 (29509309) 31537677;Database Patch Set Update : 11.2.0.4.201020 (31537677) 29938455;OCW Patch Set Update : 11.2.0.4.191015 (29938455) OPatch succeeded. $ （2）打db psu ----db psu---- root用户执行以下命令可将GI的 29938455（ocw）、31537677（db psu）两个补丁打上 # OPatch/opatch auto /31718723 -oh输出如下： # /u01/app/oracle/product/11.2.0.4/OPatch/opatch auto /u01/software/31718723 -oh /u01/app/oracle/product/11.2.0.4 Executing /u01/app/11.2.0.4/grid/perl/bin/perl /u01/app/oracle/product/11.2.0.4/OPatch/crs/patch11203.pl -patchdir /u01/software -p atchn 31718723 -oh /u01/app/oracle/product/11.2.0.4 -paramfile /u01/app/11.2.0.4/grid/crs/install/crsconfig_params This is the main log file: /u01/app/oracle/product/11.2.0.4/cfgtoollogs/opatchauto2020-12-14_11-39-41.log This file will show your detected configuration and all the steps that opatchauto attempted to do on your system: /u01/app/oracle/product/11.2.0.4/cfgtoollogs/opatchauto2020-12-14_11-39-41.report.log 2020-12-14 11:39:41: Starting Clusterware Patch Setup Using configuration parameter file: /u01/app/11.2.0.4/grid/crs/install/crsconfig_params Stopping RAC /u01/app/oracle/product/11.2.0.4 ... Stopped RAC /u01/app/oracle/product/11.2.0.4 successfully patch /u01/software/31718723/29938455/custom/server/29938455 apply successful for home /u01/app/oracle/product/11.2.0.4 patch /u01/software/31718723/31537677 apply successful for home /u01/app/oracle/product/11.2.0.4 Starting RAC /u01/app/oracle/product/11.2.0.4 ... Started RAC /u01/app/oracle/product/11.2.0.4 successfully opatch auto succeeded. # 2、打31668908（OJVM）补丁（1）停crs服务
一个个停，一个个打，这样最起码确保有一个节点是安全的（生产环境尤其重要！） 停止当前crs # /u01/app/11.2.0.4/grid/bin/crsctl stop crs crs状态 # /u01/app/11.2.0.4/grid/bin/crsctl status resource -t（2）OJVM要使用oracle用户下的opatch打 # su - oracle $ opatch apply /31668908输出如下： $ opatch apply /u01/software/31668908 Oracle Interim Patch Installer version 11.2.0.3.27 Copyright (c) 2020, Oracle Corporation. All rights reserved. Oracle Home : /u01/app/oracle/product/11.2.0.4 Central Inventory : /u01/app/oraInventory from : /u01/app/oracle/product/11.2.0.4/oraInst.loc OPatch version : 11.2.0.3.27 OUI version : 11.2.0.4.0 Log file location : /u01/app/oracle/product/11.2.0.4/cfgtoollogs/opatch/opatch2020-12-14_11-58-40AM_1.log Verifying environment and performing prerequisite checks... OPatch continues with these patches: 31668908 Do you want to proceed? [y|n] y User Responded with: Y All checks passed. Please shutdown Oracle instances running out of this ORACLE_HOME on the local system. (Oracle Home = '/u01/app/oracle/product/11.2.0.4') Is the local system ready for patching? [y|n] y User Responded with: Y Backing up files... Applying interim patch '31668908' to OH '/u01/app/oracle/product/11.2.0.4' ApplySession: Optional component(s) [ oracle.sqlj, 11.2.0.4.0 ] , [ oracle.sqlj.companion, 11.2.0.4.0 ] not present in the Oracle Hom e or a higher version is found. Patching component oracle.javavm.server, 11.2.0.4.0... Patching component oracle.precomp.common, 11.2.0.4.0... Patching component oracle.rdbms, 11.2.0.4.0... Patching component oracle.rdbms.dbscripts, 11.2.0.4.0... Patching component oracle.javavm.client, 11.2.0.4.0... Patching component oracle.dbjava.jdbc, 11.2.0.4.0... Patching component oracle.dbjava.ic, 11.2.0.4.0... Patch 31668908 successfully applied. Log file location: /u01/app/oracle/product/11.2.0.4/cfgtoollogs/opatch/opatch2020-12-14_11-58-40AM_1.log OPatch succeeded. $（3）打完补丁后执行脚本 1、将修改后的SQL文件加载到数据库中： 以下步骤将修改后的SQL文件加载到数据库中。对于Oracle RAC环境，请仅在一个节点上执行这些步骤。 (1)通过为单实例环境运行以下命令来安装补丁程序的SQL部分。 cd $ORACLE_HOME/sqlpatch/31668908 sqlplus /nolog SQL> CONNECT / AS SYSDBA SQL> startup upgrade SQL> @postinstall.sql SQL> shutdown SQL> startup (2)对于Oracle RAC环境，请使用以下命令在一个节点上重新加载程序包。确保远程节点上没有其他数据库实例在运行。 cd $ORACLE_HOME/sqlpatch/31668908 sqlplus /nolog SQL> CONNECT / AS SYSDBA SQL> STARTUP SQL> alter system set cluster_database=false scope=spfile; SQL> SHUTDOWN SQL> STARTUP UPGRADE SQL> @postinstall.sql SQL> alter system set cluster_database=true scope=spfile; SQL> SHUTDOWN SQL> STARTUP (3)安装补丁的SQL部分后，某些软件包可能变为无效。访问时将重新编译该文件，或者您可以运行utlrp.sql以使其恢复为有效状态。 cd $ORACLE_HOME/rdbms/admin sqlplus /nolog SQL> CONNECT / AS SYSDBA SQL> @utlrp.sql查看已安装的Oracle补丁 #1、在操作系统中查看补丁版本： # su - oracle Last login: Mon Dec 14 11:46:56 CST 2020 on pts/4 [csxgdb2][oracle@csxgdb2 ~]$ opatch lspatches 31537677;Database Patch Set Update : 11.2.0.4.201020 (31537677) 29938455;OCW Patch Set Update : 11.2.0.4.191015 (29938455) OPatch succeeded. #2、查看具体的补丁号： $ opatch lsinventory #3、在数据库中查询补丁版本： set line 200 col ACTION_TIME for a35 col COMMENTS for a45 select ACTION_TIME,version,COMMENTS from registry$history;至此单个节点的gi和db的补丁全部安装完毕，第二个节点按照相同操作即可，详情请参考补丁解压文件readme，谢谢。 原文链接：https://blog.csdn.net/ly7472712/article/details/111186830 |
【本文地址】
今日新闻 |
推荐新闻 |